ΠΕΡΙΓΡΑΦΗ

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules  Microsoft Access lets ordinary users develop powerful apps customized for their business needs.   

In this course experienced Microsoft Access trainer Kathy Jones will build upon the basics of tables, queries, forms, and reports covered in the Basics course.  Starting with the basics of relational database design, this course will expand your knowledge of Microsoft Access by covering topics such as table relationships, query joins, subdatasheets, field validation, parameter queries, and more.  

In this course you will learn how to:  

• Design a relational database
• Join tables to retrieve data from unrelated tables
• Validate data entered into a database
• Use advanced queries to manipulate your data
• Organize a database for efficiency and performance, and to maintain data integrity
• Customize reports to organize the displayed information and produce specific print layouts 

Quickly Search For And Find The Skills You Want To Master– Then Just Point, Click, And Learn Over two hours of high quality HD content in Teacher/Learner style! 

Modules Include: 

1. Relational Database Design
2. Creating a Table
3. Creating Table Relationships 
4. Creating Query Joins 
5. Relating Data Within A Table 
6. Working with Subdata Sheets
7. Using Field Validation, Part 1 
8. Using Field Validation, Part 2 
9. Using Forms and Record Validation 
10. Creating Parameter Queries 
11. Summarizing Data 
12. Creating Subqueries
13. Creating Action Queries 
14. Creating Unmatched/Duplicate Queries
15. Data Normalization  16: Creating a Junction Table 
16. Creating a Table Structure 
17. Including Control Formatting in a Report 
18. Adding Calculated Fields to a Report 
19. Adding a Sub-Report to an Existing Report